package com.company.cloud.product.modules.app.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface SaasSitMapMapper {
	
	
	/**
	 * 商品
	 * */
	@Select(" SELECT product_no as id from prd_product_info where rows_state='1' and is_marketable='1' ")
	public List<String> prdSitMap();

	
	/**
	 * 艺术家
	 * */
	@Select(" SELECT artist_no as id from art_artist_info where rows_state='1' ")
	public List<String> artistSitMap();
	
	/**
	 * 新闻
	 * */
	@Select(" SELECT article_rel_no as id from cms_article_company_rel_info where rows_state='1' ")
	public List<String> newsSitMap();
	
	/**
	 * 机构
	 * */
	@Select(" SELECT company_no as id from com_company_info where rows_state='1' ")
	public List<String> organSitMap();
	
	@Insert("${paramSQL}")
	public void dynamicsInsert(@Param("paramSQL") String sql);
	
	@Update("${paramSQL}")
    public void dynamicsUpdate(@Param("paramSQL") String sql);
	
	@Delete("${paramSQL}")
    public void dynamicsDelete(@Param("paramSQL") String sql);

}
